Release 10.1A: OpenEdge Data Management:
SQL Reference

GROUP BY clause

Specifies grouping of rows in the result table.

Syntax

GROUP BY [ table_name.]column_name ...

Notes

For the first column specified in the GROUP BY clause, SQL arranges rows of the result table into groups whose rows all have the same values for the specified column.
If you specify a second GROUP BY column, SQL groups rows in each main group by values of the second column.
SQL groups rows for values in additional GROUP BY columns in a similar fashion.
All columns named in the GROUP BY clause must also be in the select list of the query expression. Conversely, columns in the select list must also be in the GROUP BY clause or be part of an aggregate function.

Example

This example retrieves name and order info for customers with orders:

SELECT DeptCode, LastName FROM Employee GROUP BY DeptCode;